package org.light.verb;

import java.util.ArrayList;
import java.util.List;
import java.util.Set;

import org.light.core.Verb;
import org.light.core.Writeable;
import org.light.domain.Domain;
import org.light.domain.Dropdown;
import org.light.domain.Field;
import org.light.domain.JavascriptBlock;
import org.light.domain.JavascriptMethod;
import org.light.domain.Method;
import org.light.domain.Signature;
import org.light.domain.Statement;
import org.light.domain.StatementList;
import org.light.domain.Type;
import org.light.domain.Var;
import org.light.easyui.EasyUIPositions;
import org.light.generator.NamedStatementGenerator;
import org.light.generator.NamedStatementListGenerator;
import org.light.utils.InterVarUtil;
import org.light.utils.StringUtil;
import org.light.utils.WriteableUtil;

public class Update extends Verb implements EasyUIPositions {

	@Override
	public Method generateDaoImplMethod() {
		Method method = new Method();
		method.setStandardName("update"+StringUtil.capFirst(this.domain.getStandardName()));
		method.setReturnType(new Type("boolean"));
		method.setThrowException(true);
		method.addAdditionalImport("java.sql.Connection");
		method.addAdditionalImport("java.util.List");
		method.addAdditionalImport("java.util.ArrayList");
		method.addAdditionalImport("java.sql.PreparedStatement");
		method.addAdditionalImport("java.sql.ResultSet");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDomainSuffix()+"."+this.domain.getCapFirstDomainNameWithSuffix());
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDaoSuffix()+"."+this.domain.getStandardName()+"Dao");
		method.addSignature(new Signature(1,InterVarUtil.DB.connection.getVarName(),InterVarUtil.DB.connection.getVarType()));
		method.addSignature(new Signature(2, StringUtil.lowerFirst(this.domain.getStandardName()), this.domain.getType()));
		if (this.domain.containsDateTime()) {
			method.addAdditionalImport(this.domain.getPackageToken()+".utils.DateUtil");
		}

		List<Writeable> list = new ArrayList<Writeable>();
		list.add(NamedStatementGenerator.getUpdateSqlStatementWithDeniedFields(1000L,2, this.domain,InterVarUtil.DB.query,this.deniedFields));
		list.add(NamedStatementGenerator.getPrepareStatement(2000L,2, InterVarUtil.DB.ps, InterVarUtil.DB.query, InterVarUtil.DB.connection));
		list.add(NamedStatementListGenerator.generatePsSetDomainFieldsEndWithIdWithDeniedFields(3000L, 2,this.domain, InterVarUtil.DB.ps, this.deniedFields));
		list.add(NamedStatementGenerator.getPrepareStatementExcuteUpdate(4000L,2, InterVarUtil.DB.result, InterVarUtil.DB.ps));
		list.add(NamedStatementListGenerator.generateResultReturnSuccess(5000L,2, InterVarUtil.DB.result));
		method.setMethodStatementList(WriteableUtil.merge(list));
		return method;
	}

	@Override
	public Method generateDaoMethodDefinition() {
		Method method = new Method();
		method.setStandardName("update"+StringUtil.capFirst(this.domain.getStandardName()));
		method.setReturnType(new Type("boolean"));
		method.setThrowException(true);
		method.addAdditionalImport("java.sql.Connection");
		method.addAdditionalImport("java.util.List");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDomainSuffix()+"."+this.domain.getCapFirstDomainNameWithSuffix());
		method.addSignature(new Signature(1,InterVarUtil.DB.connection.getVarName(),InterVarUtil.DB.connection.getVarType()));
		method.addSignature(new Signature(2, StringUtil.lowerFirst(this.domain.getStandardName()), this.domain.getType()));
		return method;
	}

	@Override
	public Method generateServiceMethodDefinition() {
		Method method = new Method();
		method.setStandardName("update"+StringUtil.capFirst(this.domain.getStandardName()));
		method.setReturnType(new Type("boolean"));
		method.setThrowException(true);
		method.addAdditionalImport("java.util.List");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDomainSuffix()+"."+this.domain.getCapFirstDomainNameWithSuffix());
		method.addSignature(new Signature(2, StringUtil.lowerFirst(this.domain.getStandardName()), this.domain.getType()));
		return method;
	}

	@Override
	public Method generateServiceImplMethod() {
		Method method = new Method();
		method.setStandardName("update"+StringUtil.capFirst(this.domain.getStandardName()));
		method.setReturnType(new Type("boolean"));
		method.setThrowException(true);
		method.addAdditionalImport("java.sql.Connection");
		method.addAdditionalImport("java.util.List");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDomainSuffix()+"."+this.domain.getCapFirstDomainNameWithSuffix());
		method.addAdditionalImport(this.domain.getPackageToken()+".database.DBConf");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDaoSuffix()+"."+this.domain.getStandardName()+"Dao");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDaoimplSuffix()+"."+this.domain.getStandardName()+"DaoImpl");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getServiceSuffix()+"."+this.domain.getStandardName()+"Service");
		method.addSignature(new Signature(1, StringUtil.lowerFirst(this.domain.getStandardName()), this.domain.getType()));
		
		//Service method
		Method daomethod = this.generateDaoMethodDefinition();
				
		List<Writeable> list = new ArrayList<Writeable>();
		list.add(NamedStatementListGenerator.generateServiceImplReturnBoolean(1000L, 2, InterVarUtil.DB.connection, InterVarUtil.DB.dbconf, InterVarUtil.DB.dao, daomethod));
		method.setMethodStatementList(WriteableUtil.merge(list));
		return method;
	}
	
	public Update(Domain domain){
		super();
		this.domain = domain;
		this.setVerbName("Update"+StringUtil.capFirst(this.domain.getStandardName()));
	}

	public Update(Domain domain, Set<Field> deniedFields){
		super();
		this.domain = domain;
		this.deniedFields = deniedFields;
		this.setVerbName("Update"+StringUtil.capFirst(this.domain.getStandardName()));
	}
	
	public Update(){
		super();
	}

	@Override
	public Method generateControllerMethod() {
		Method method = new Method();
		method.setStandardName("processRequest");
		method.setReturnType(new Type("void"));
		method.setThrowException(true);
		List<String> list = new ArrayList<String>();
		list.add("ServletException");
		list.add("IOException");
		method.setIsprotected(true);
		method.setOtherExceptions(list);
		method.addSignature(new Signature(1,"request",new Type("HttpServletRequest","javax.servlet.http")));
		method.addSignature(new Signature(2,"response",new Type("HttpServletResponse","javax.servlet.http")));
		method.addAdditionalImport("java.io.IOException");
		method.addAdditionalImport("java.io.PrintWriter");
		method.addAdditionalImport("javax.servlet.ServletException");
		method.addAdditionalImport("javax.servlet.http.HttpServlet");
		method.addAdditionalImport("javax.servlet.http.HttpServletRequest");
		method.addAdditionalImport("javax.servlet.http.HttpServletResponse");
		method.addAdditionalImport("java.util.Map");
		method.addAdditionalImport("java.util.TreeMap");
		method.addAdditionalImport("net.sf.json.JSONObject");
		method.addAdditionalImport("java.io.BufferedReader");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDomainSuffix()+"."+this.domain.getCapFirstDomainNameWithSuffix());
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getServiceSuffix()+"."+this.domain.getStandardName()+"Service");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getServiceimplSuffix()+"."+this.domain.getStandardName()+"ServiceImpl");
		if (this.domain.containsDateTime()){
			method.addAdditionalImport(this.domain.getPackageToken()+".utils.DateUtil");
		}

		List<Writeable> wlist = new ArrayList<Writeable>();
		Var resultMap = new Var("result", new Type("TreeMap<String,Object>","java.util"));		
		Var service = new Var("service", new Type(this.domain.getStandardName()+"Service",this.domain.getPackageToken()));
		wlist.add(NamedStatementGenerator.getFacadeSetContentType(1000L, 2, InterVarUtil.Servlet.response, InterVarUtil.SimpleJEE.UTF8.getVarName()));
		wlist.add(NamedStatementGenerator.getControllerPrintWriterOut(2000L, 2, InterVarUtil.Servlet.response, InterVarUtil.Servlet.out));
		wlist.add(NamedStatementGenerator.getJsonResultMap(3000L, 2, resultMap));
		wlist.add(NamedStatementGenerator.getTryHead(4000L, 2));
		wlist.add(NamedStatementGenerator.getPrepareDomainVarInit(5000L, 3, this.domain));
		wlist.add(NamedStatementListGenerator.generateJsonRequest(5500L, 3, InterVarUtil.Servlet.request));
		wlist.add(NamedStatementListGenerator.generateSetDomainDataFromJsonRequest(6000L, 3, this.domain, InterVarUtil.Servlet.jsonRequest));
		wlist.add(NamedStatementGenerator.getPrepareService(7000L,3, service));

		long serial = 8000L;
		boolean imageExists = this.domain.containsImage();
		if (imageExists) 
		{
			wlist.add(new Statement(serial,3,this.domain.getCapFirstDomainNameWithSuffix() +" ori"+this.domain.getCapFirstDomainName()+
					" = service.find"+this.domain.getCapFirstDomainName()+"By"+this.domain.getDomainId().getCapFirstFieldName()+"("+this.domain.getLowerFirstDomainName()+".get"+this.domain.getDomainId().getCapFirstFieldName()+"());"));
			serial += 1000L;
		}
		for (Field f:this.domain.getPlainFields()) {
			if (!this.deniedFields.contains(f)) {
				if (f.getFieldType().equalsIgnoreCase("image")) {
					imageExists = true;
					wlist.add(new Statement(serial,3,"if (ori"+this.domain.getCapFirstDomainName()+".get"+f.getCapFirstFieldName()+"()!=null) {"));
					wlist.add(new Statement(serial+1000L,4,this.domain.getLowerFirstDomainName()+".set"+f.getCapFirstFieldName()+"(ori"+this.domain.getCapFirstDomainName()+".get"+f.getCapFirstFieldName()+"());"));
					wlist.add(new Statement(serial+2000L,3,"}"));
					serial += 3000L;
				}		
			}
		}
		for (Field f:this.domain.getPlainFields()) {
			if (!this.deniedFields.contains(f)) {
				if (f.getFieldType().equalsIgnoreCase("image")) {
					wlist.add(new Statement(serial,3,"if ("+this.domain.getCapFirstDomainName()+"ServiceImpl.temp"+this.domain.getCapFirstDomainName()+"!=null && "+this.domain.getCapFirstDomainName()+"ServiceImpl.temp"+this.domain.getCapFirstDomainName()+".get"+f.getCapFirstFieldName()+"()!=null) {"));
					wlist.add(new Statement(serial+1000L,4,this.domain.getLowerFirstDomainName()+".set"+f.getCapFirstFieldName()+"("+this.domain.getCapFirstDomainName()+"ServiceImpl.temp"+this.domain.getCapFirstDomainName()+".get"+f.getCapFirstFieldName()+"());"));
					wlist.add(new Statement(serial+2000L,3,"}"));
					serial += 3000L;
				}		
			}
		}
		if (imageExists) 
		{
			wlist.add(new Statement(serial+1000L,3,this.domain.getCapFirstDomainName()+"ServiceImpl.temp"+this.domain.getCapFirstDomainName()+" = new  "+this.domain.getCapFirstDomainNameWithSuffix()+"();"));
			serial += 2000L;
		}	

		
		wlist.add(NamedStatementGenerator.getCallServiceMethodAssignSuccess(serial + 1000L, 3, service, generateServiceMethodDefinition()));
		wlist.add(NamedStatementListGenerator.getPutJsonResultMapWithSuccessAssignAndNull(serial + 2000L, 3, resultMap));
		wlist.add(NamedStatementGenerator.getEncodeMapToJsonResultMap(serial + 3000L, 3, resultMap,InterVarUtil.Servlet.out));
		wlist.add(NamedStatementListGenerator.generateCatchExceptionPrintStackPrintJsonMapFinallyCloseOutFooter(serial + 4000L, 2, InterVarUtil.Servlet.response,resultMap, InterVarUtil.Servlet.out));
		method.setMethodStatementList(WriteableUtil.merge(wlist));
		
		return method;
	}

	@Override
	public JavascriptBlock generateEasyUIJSButtonBlock() throws Exception {
		JavascriptBlock block = new JavascriptBlock();
		block.setSerial(100);
		block.setStandardName("Update"+domain.getCapFirstDomainName());
		StatementList sl = new StatementList();
		sl.add(new Statement(1000,0, "{"));
		sl.add(new Statement(2000,1, "text:'编辑',"));
		sl.add(new Statement(3000,1, "iconCls:'icon-edit',"));
		sl.add(new Statement(4000,1, "handler:function(){ "));
		sl.add(new Statement(5000,2, "var rows = $(\"#dg\").datagrid(\"getChecked\");"));
		sl.add(new Statement(6000,2, "if (rows == undefined || rows == null || rows.length == 0 ){"));
		sl.add(new Statement(7000,3, "$.messager.alert(\"警告\",\"请选定一条记录！\",\"warning\");"));
		sl.add(new Statement(8000,3, "return;"));
		sl.add(new Statement(9000,2, "}"));	
		sl.add(new Statement(10000,2, "if (rows.length > 1) {"));
		sl.add(new Statement(11000,3, "$.messager.alert(\"警告\",\"请选定一条记录！\",\"warning\");"));
		sl.add(new Statement(12000,3, "return;"));
		sl.add(new Statement(13000,2, "}"));
		sl.add(new Statement(13500,2, "$(\"#ffedit\").find(\"#"+this.domain.getDomainId().getLowerFirstFieldName()+"\").val(rows[0][\""+this.domain.getDomainId().getLowerFirstFieldName()+"\"]);"));
		long serial = 14000;
		for (Field f: domain.getFieldsWithoutIdAndActive()){
			if (f.getFieldType().equalsIgnoreCase("image")) {
				sl.add(new Statement(serial, 2, "if (!isBlank(rows[0][\""+f.getLowerFirstFieldName()+"\"]))	{"));
				sl.add(new Statement(serial+10, 3, "$(\"#ffedit\").find(\"#"+f.getLowerFirstFieldName()+"\").prop(\"src\",\"data:image/png;base64,\"+rows[0][\""+f.getLowerFirstFieldName()+"\"]);"));
				sl.add(new Statement(serial+20, 2, "}else{"));
				sl.add(new Statement(serial+30, 3, "$(\"#ffedit\").find(\"#"+f.getLowerFirstFieldName()+"\").prop(\"src\",\"../images/blank.jpg\");"));
				sl.add(new Statement(serial+40, 2, "}"));
			}else if (f.getFieldType().equalsIgnoreCase("boolean")){
				sl.add(new Statement(serial,2, "checkRadioBoxValue(\"ffedit\",\""+f.getLowerFirstFieldName()+"\",rows[0][\""+f.getLowerFirstFieldName()+"\"]);"));
			}else if (f instanceof Dropdown){
				sl.add(new Statement(serial,2, "$(\"#ffedit\").find(\"#"+f.getLowerFirstFieldName()+"\").combobox(\"setValue\",rows[0][\""+f.getLowerFirstFieldName()+"\"]);"));
			} else if (f.isTextarea()) {
				sl.add(new Statement(serial, 2, "$(\"#ffedit\").find(\"#" + f.getLowerFirstFieldName()
						+ "\").val(rows[0][\"" + f.getLowerFirstFieldName() + "\"]);"));
			} else{
				sl.add(new Statement(serial,2, "$(\"#ffedit\").find(\"#"+f.getLowerFirstFieldName()+"\").textbox(\"setValue\",rows[0][\""+f.getLowerFirstFieldName()+"\"]);"));
			}
			serial+=1000;
		}			
		sl.add(new Statement(serial,2, "var checkboxs = $(\"#ffedit\").find(\"input[name='"+this.domain.getActive().getLowerFirstFieldName()+"']\");"));
		sl.add(new Statement(serial+100,2, "for (var i=0;i<checkboxs.length;i++){"));
		sl.add(new Statement(serial+200,3, "if (checkboxs.get(i).value == \"\"+rows[0][\""+this.domain.getActive().getLowerFirstFieldName()+"\"]) checkboxs.get(i).checked=true;"));
		sl.add(new Statement(serial+500,2, "}"));
		sl.add(new Statement(serial+1000,2, "$('#wupdate"+domain.getCapFirstDomainName()+"').window('open');"));
		sl.add(new Statement(serial+2000,1, "}"));
		sl.add(new Statement(serial+3000,0, "}"));
		block.setMethodStatementList(sl);
		return block;		
	}

	@Override
	public JavascriptMethod generateEasyUIJSActionMethod() throws Exception {
		Domain domain = this.domain;
		JavascriptMethod method = new JavascriptMethod();
		method.setSerial(200);
		method.setStandardName("update"+domain.getCapFirstDomainName());
				
		StatementList sl = new StatementList();
		sl.add(new Statement(1000,1, "$.ajax({"));
		sl.add(new Statement(2000,2, "type: \"post\","));
		sl.add(new Statement(3000,2, "url: \"../"+domain.getControllerPackagePrefix()+domain.getLowerFirstDomainName()+domain.getControllerNamingSuffix()+"/"+StringUtil.lowerFirst(this.getVerbName())+"\","));
		sl.add(new Statement(4000, 2, "data: JSON.stringify({"));
		long serial = 5000;
		for (Field f: domain.getFields()){
			if (f instanceof Dropdown){
				sl.add(new Statement(serial,3, f.getLowerFirstFieldName()+":$(\"#ffedit\").find(\"#"+f.getLowerFirstFieldName()+"\").combobox(\"getValue\"),"));
			} else if (f.getFieldType().equalsIgnoreCase("boolean")){
				sl.add(new Statement(serial,3, f.getLowerFirstFieldName()+":parseBoolean($(\"#ffedit\").find(\"input[name='"+f.getLowerFirstFieldName()+"']:checked\").val()),"));	
			} else {
				sl.add(new Statement(serial,3, f.getLowerFirstFieldName()+":$(\"#ffedit\").find(\"#"+f.getLowerFirstFieldName()+"\").val(),"));
			}
			serial+=1000;
		}
		sl.add(new Statement(serial,2, "}),"));
		sl.add(new Statement(serial+1000, 2, "dataType: 'json',"));
		sl.add(new Statement(serial+2000, 2, "contentType:\"application/json;charset=UTF-8\","));
		sl.add(new Statement(serial+3000,2, "success: function(data, textStatus) {"));
		sl.add(new Statement(serial+4000,3, "if (data.success){"));
		sl.add(new Statement(serial+5000,4, "$('#ffedit').form('clear');"));
		sl.add(new Statement(serial+6000,4, "$(\"#ffedit\").find(\"input[name='"+domain.getActive().getLowerFirstFieldName()+"']\").get(0).checked = true;"));
		sl.add(new Statement(serial+7000,4, "$(\"#wupdate"+domain.getCapFirstDomainName()+"\").window('close');"));
		sl.add(new Statement(serial+8000,4, "$(\"#dg\").datagrid(\"load\");"));
		sl.add(new Statement(serial+9000,3, "}"));
		sl.add(new Statement(serial+10000,2, "},"));
		sl.add(new Statement(serial+11000,2, "complete : function(XMLHttpRequest, textStatus) {"));
		sl.add(new Statement(serial+12000,2, "},"));
		sl.add(new Statement(serial+13000,2, "error : function(XMLHttpRequest,textStatus,errorThrown) {"));
		sl.add(new Statement(serial+14000,3, "alert(\"Error:\"+textStatus);"));
		sl.add(new Statement(serial+15000,3, "alert(errorThrown.toString());"));
		sl.add(new Statement(serial+16000,2, "}"));
		sl.add(new Statement(serial+17000,1, "}); "));
		
		method.setMethodStatementList(sl);
		return method;		
	}
	
	@Override
	public Method generateDummyDaoImplMethod() throws Exception {
		if (this.denied)
			return null;
		else {
			Method method = new Method();
			method.setStandardName(StringUtil.lowerFirst(getVerbName()));
			method.setReturnType(new Type("boolean"));
			method.setThrowException(true);
			method.addAdditionalImport(this.domain.getPackageToken() + "." + this.domain.getDomainSuffix() + "."
					+ this.domain.getCapFirstDomainNameWithSuffix());
			method.addSignature(
					new Signature(1, StringUtil.lowerFirst(this.domain.getStandardName()), this.domain.getType()));			
			
			List<Writeable> sList = new ArrayList<Writeable>();
			sList.add(new Statement(1000L,2,"for (int i = 0;i < db.size(); i++) {"));
			sList.add(new Statement(2000L,3,"if (db.get(i).get"+this.domain.getDomainId().getCapFirstFieldName()+"() == "+this.domain.getLowerFirstDomainName()+".get"+this.domain.getDomainId().getCapFirstFieldName()+"()) {"));
			sList.add(new Statement(3000L,4,"db.set(i, "+this.domain.getLowerFirstDomainName()+");"));
			sList.add(new Statement(4000L,3,"}"));
			sList.add(new Statement(5000L,2,"}"));
			sList.add(new Statement(6000L,2,"return true;"));
			method.setMethodStatementList(WriteableUtil.merge(sList));
			
			return method;
		}
	}

	@Override
	public Method generateDummyServiceImplMethod() throws Exception {
		Method method = new Method();
		method.setStandardName("update"+StringUtil.capFirst(this.domain.getStandardName()));
		method.setReturnType(new Type("boolean"));
		method.setThrowException(true);
		method.addAdditionalImport("java.util.List");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDomainSuffix()+"."+this.domain.getCapFirstDomainNameWithSuffix());
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDaoSuffix()+"."+this.domain.getStandardName()+"Dao");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDaoimplSuffix()+"."+this.domain.getStandardName()+"DummyDaoImpl");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getServiceSuffix()+"."+this.domain.getStandardName()+"Service");
		method.addSignature(new Signature(1, StringUtil.lowerFirst(this.domain.getStandardName()), this.domain.getType()));

		Method daomethod = this.generateDummyDaoMethodDefinition();				
		List<Writeable> list = new ArrayList<Writeable>();
		list.add(NamedStatementListGenerator.generateDummyServiceImplReturnBoolean(1000L, 2, InterVarUtil.DB.dao, daomethod));
		method.setMethodStatementList(WriteableUtil.merge(list));
		return method;
	}

	@Override
	public Method generateDummyDaoMethodDefinition() throws Exception {
		Method method = new Method();
		method.setStandardName("update"+StringUtil.capFirst(this.domain.getStandardName()));
		method.setReturnType(new Type("boolean"));
		method.setThrowException(true);
		method.addAdditionalImport("java.util.List");
		method.addAdditionalImport(this.domain.getPackageToken()+"."+this.domain.getDomainSuffix()+"."+this.domain.getCapFirstDomainNameWithSuffix());
		method.addSignature(new Signature(1, StringUtil.lowerFirst(this.domain.getStandardName()), this.domain.getType()));
		return method;
	}
}
